package pl.register.android.database.tables;

/**
 * @author Mateusz Strzelecki
 * @since 2013-04-14
 */

public class StudentClassNumberDBTable {
    private static final String SEPARATOR = ".";
	public static final String TABLE_NAME = "StudentClassNumber";

	public static final String CLASS_NUMBER = "student_class_number";
	public static final String FK_STUDENT_ID = "student_class_number_fk_student_id";
	public static final String FK_COURSE_ID = "student_class_number_fk_course_id";

    public static final String CLASSNUMBER_CLASS_NUMBER = TABLE_NAME + SEPARATOR + CLASS_NUMBER;
    public static final String CLASSNUMBER_FK_STUDENT_ID = TABLE_NAME + SEPARATOR + FK_STUDENT_ID;
    public static final String CLASSNUMBER_FK_COURSE_ID = TABLE_NAME + SEPARATOR + FK_COURSE_ID ;

    public interface Query {
        public static final String CREATE_TABLE =
                "CREATE TABLE IF NOT EXISTS " + TABLE_NAME +
                        "(" +
                        CLASS_NUMBER + " TEXT NOT NULL, " +
                        FK_STUDENT_ID + " INTEGER NOT NULL, " +
                        FK_COURSE_ID + " INTEGER NOT NULL" +
                        ");";

        public static final String DROP_TABLE =
                "DROP TABLE IF EXISTS " + TABLE_NAME + ";";
    }

}